UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HDtgACW9Wa5TRHMbLYCBgjCRNTV6+EOlXYYstpypZsg='
WHERE
key_id = 'd7c296c3b6bbc6938f50685dfc8dc5b4a296b34b098b4d837a68875461a34f00'
AND (
token = 'HDtgACW9Wa5TRHMbLYCBgjCRNTV6+EOlXYYstpypZsg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)