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