UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9W2WiYUUDvfsm+XGZQlZc5GZ7B2N4ERX7gCxr0nuGhY='
WHERE
key_id = '5c7cf860c485dc4786a1cfeec4c31d1d2d56d42d1b974ff0c0ac96fa4ed2ad28'
AND (
token = '9W2WiYUUDvfsm+XGZQlZc5GZ7B2N4ERX7gCxr0nuGhY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)