UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vfy6BXxwzcQT94VkLEv3xs6NdWPLV+5YA7Em+xrCrUU='
WHERE
key_id = '8cafd521f67e273a3a50eaf858242b4b8016ee47b9ce6807c39853f6d416d166'
AND (
token = 'Vfy6BXxwzcQT94VkLEv3xs6NdWPLV+5YA7Em+xrCrUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)