UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XwIIKk9qbUhkco5pqmlX4uO/xKupal7pbHN9PZ+gjRg='
WHERE
key_id = '1a504157546823ae0b7da9256add8ce820b5373b9b7ee6dcd9dc71b137bc46aa'
AND (
token = 'XwIIKk9qbUhkco5pqmlX4uO/xKupal7pbHN9PZ+gjRg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)