UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SjICUiYuAdcKadyHWkAw1uyjI8Rf/qaz8FHsecTqs3o='
WHERE
key_id = 'de2365913dc087e079c71dc4ae0f083bbf907e71a23772d5c1e03c5fd9470ea9'
AND (
token = 'SjICUiYuAdcKadyHWkAw1uyjI8Rf/qaz8FHsecTqs3o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)