UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UjRC4qqcMPNHDjjPXybeFfHSE0wd1m41C9xYDT+oDmU='
WHERE
key_id = 'dfb144210c547bdbad96f90337e9917cd8f08e003e0d8e3e920a5e96fd55a2fe'
AND (
token = 'UjRC4qqcMPNHDjjPXybeFfHSE0wd1m41C9xYDT+oDmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)