UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nnt/mElD505W7+VZP3aW3+4XTVBdmnH54tzWZNr0Rrw='
WHERE
key_id = '974debf1e6ca176e5c8d8dce04d372ff72228b4d7601d7564cc8ed29c9b2b86d'
AND (
token = 'Nnt/mElD505W7+VZP3aW3+4XTVBdmnH54tzWZNr0Rrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)