UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kTIFDdvwh+EE+uLnd3D6GhLnX6n0HOj024iVPpiC+xg='
WHERE
key_id = 'c42db190afb981f8971352267da4b865e52b59070b03cf186f3ee465cb370045'
AND (
token = 'kTIFDdvwh+EE+uLnd3D6GhLnX6n0HOj024iVPpiC+xg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)