UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IJggNe57BZXA4rTWoPXXIWc0Mm0SxiSiw6fxQ70VHqE='
WHERE
key_id = '1eaefb74d171d7c0aeb9a86fcb1d37a3c8d0ec80b9de3fd8abc3bef406a10d4e'
AND (
token = 'IJggNe57BZXA4rTWoPXXIWc0Mm0SxiSiw6fxQ70VHqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)