UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J9CWENX0lmANVYf3DVbw+1pir4oQswFE7CceKGFhfS8='
WHERE
key_id = '55b34fbe2751154a009ae321fad0b9c6813a7b529b64cbee7286ba2e138a90d3'
AND (
token = 'J9CWENX0lmANVYf3DVbw+1pir4oQswFE7CceKGFhfS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)