UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sAkG12uHMVsiBd5DJzeugbSaeTLuPwEZ09OsQq2JKDo='
WHERE
key_id = 'd508cedf81f890afaf9d73e989d2163c8c42f877ba612d9f013ffe9af3e34452'
AND (
token = 'sAkG12uHMVsiBd5DJzeugbSaeTLuPwEZ09OsQq2JKDo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)