UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1YL4MvibniFjLyDt8YBCBoM8fa6UJ3bQ2uL1CRPgMw0='
WHERE
key_id = 'ab490bc3928d9f3003f24a3cf99078028bd32c855588f98ce77e1d8a7c4cf4f3'
AND (
token = '1YL4MvibniFjLyDt8YBCBoM8fa6UJ3bQ2uL1CRPgMw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)