UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WX/W+pTkN1Omyr93FwIL3v5BoGTqQUGkIn0muwiTmT8='
WHERE
key_id = '8505689d129def31006bac4449b464d330ab84932c8a22bcbfe828c3a909d43f'
AND (
token = 'WX/W+pTkN1Omyr93FwIL3v5BoGTqQUGkIn0muwiTmT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)