UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pXhc7gry7octts3L7IHF/fsPRGIv3+NB9DgXYulv0xM='
WHERE
key_id = 'cea6042715e48afab6677c662aa225cc263a61600c99682c7f8d66f5f9aa83ae'
AND (
token = 'pXhc7gry7octts3L7IHF/fsPRGIv3+NB9DgXYulv0xM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)