UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qBjGJQyAXxPNoC9OFC6a2DRjFQggqgoprITEqUiqwNo='
WHERE
key_id = 'a4324c5c6280e252100d25bd9bab28ccf18a4c2a6cf4e053935f08b42d017d65'
AND (
token = 'qBjGJQyAXxPNoC9OFC6a2DRjFQggqgoprITEqUiqwNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)