UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eV4owVlhAPIZ6uvOJgvJnLJAeDjmZs1E2igniNoHYO0='
WHERE
key_id = '0e0d844c03afba01fac5bda6147013f4596e16639634b6c401b34e89b5947cd1'
AND (
token = 'eV4owVlhAPIZ6uvOJgvJnLJAeDjmZs1E2igniNoHYO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)