UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RoyT62AbGjgQJUZ+I00v7uEJ9P4cPlYO4mH5UIr0cAg='
WHERE
key_id = 'a0531f8e78f064c2851457fc3416c07c79305d508b8120b814f0d7022a059ad6'
AND (
token = 'RoyT62AbGjgQJUZ+I00v7uEJ9P4cPlYO4mH5UIr0cAg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)