UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sna6t8Qpdr2znDhmWMtfvpVGzgCM9hh97bvE7NAa0uk='
WHERE
key_id = '9a7b350578264de370db4568c527618f790cb493e0b4900d6e98be2f2499791a'
AND (
token = 'sna6t8Qpdr2znDhmWMtfvpVGzgCM9hh97bvE7NAa0uk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)