UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D7nJ2D4OGKLEvNORoWbYHavNVsGnJZndHWf97EnPnD0='
WHERE
key_id = '0bb8a5ccaca184cb3cc77a981543dc9bf37d9bb10d3c6db950002189c378f979'
AND (
token = 'D7nJ2D4OGKLEvNORoWbYHavNVsGnJZndHWf97EnPnD0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)