UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nZQke0mbYicF/aIFtSccgwdJ5ujDMuahKC4GU6PX2cU='
WHERE
key_id = 'dd2ef5cb086377281662e517be31a09c8712a4a2bd5c2129c8a0a5a912c9f74b'
AND (
token = 'nZQke0mbYicF/aIFtSccgwdJ5ujDMuahKC4GU6PX2cU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)