UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u9GvI2rSFaWKBJ8+mT8d0rCiOG04WqW6WPmcsz3cBKk='
WHERE
key_id = 'e2667be2ab80040d3ad31612d4bbef29b2728392c071991abdadbe406f9c6a78'
AND (
token = 'u9GvI2rSFaWKBJ8+mT8d0rCiOG04WqW6WPmcsz3cBKk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)