UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jmgJo4ETp6xm3506144wS70n3j77kNkgvSY7JGa+tyo='
WHERE
key_id = '3b678a3b1fe16046edb26485eb5d1e24873b69ef4bfbb8e93b8ff7421695deac'
AND (
token = 'jmgJo4ETp6xm3506144wS70n3j77kNkgvSY7JGa+tyo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)