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