UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0BqMJugeDLpu9HSnsmo75xzLM1fnJuF+lHuSkOxu2G8='
WHERE
key_id = '8f0841d185273e547ee56c9b3238f747a75ec907700e1a0012081626ea6eacd6'
AND (
token = '0BqMJugeDLpu9HSnsmo75xzLM1fnJuF+lHuSkOxu2G8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)