UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/9FEEWjS6vFKwEUPaZgp7wQmJeMwAyhosfzZql7WNrM='
WHERE
key_id = '7739a8b10719e17362e9f4139c5968ee9ffeec41a60738b4ab8505807b6a7692'
AND (
token = '/9FEEWjS6vFKwEUPaZgp7wQmJeMwAyhosfzZql7WNrM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)