UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/cCjb7/EMuhcxNAiU38yV/VmYT5f9uNtnUTtRJlq0JI='
WHERE
key_id = '9d1953a448074669f21998ce87651bf2748f897f0b13bec94390298258726a00'
AND (
token = '/cCjb7/EMuhcxNAiU38yV/VmYT5f9uNtnUTtRJlq0JI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)