UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r8TRghMgc9mhoZ1BoaT5Hns/5t04/z1jdgdJRBNHgzw='
WHERE
key_id = '5b6b2f2f3a40b6b3c003409f4ca6753b6b5197d59fc4dbc371cc04cf9b905a01'
AND (
token = 'r8TRghMgc9mhoZ1BoaT5Hns/5t04/z1jdgdJRBNHgzw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)