UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nKbtiJXy7WcsuavOopmXovzg2/OWm0WBSho5y3F5FkE='
WHERE
key_id = '8fc9e4c44a8666ea6fce5ceeb324f544928fc35537be2a124c8a9a43225b3649'
AND (
token = 'nKbtiJXy7WcsuavOopmXovzg2/OWm0WBSho5y3F5FkE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)