UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IrX6ttyn8JsCxQoo90Im5qNLqzvMsoBArGIwDeMuZHs='
WHERE
key_id = '6a04d4a2ab46a2e66b8f9da58da82b0d4d0696fee1df0524fd98d2a47cb49929'
AND (
token = 'IrX6ttyn8JsCxQoo90Im5qNLqzvMsoBArGIwDeMuZHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)