UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZwA+BIJJkaAn6qCDbOY20jpgkZXmDvOiCNWO3s1tQdo='
WHERE
key_id = '47751a111e2732bab454fd8513062453e298b07f659eb3f774822c7925d2f8a4'
AND (
token = 'ZwA+BIJJkaAn6qCDbOY20jpgkZXmDvOiCNWO3s1tQdo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)