UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nHhivpYnF4rUqDf6UM8Urdn1CkiS7uV4Dn6EIMYi0rk='
WHERE
key_id = '4b0f8b3a83f6a4e78bb90b5c82bf427efeec7bb3fbebf71053b6c4eb1fe594a9'
AND (
token = 'nHhivpYnF4rUqDf6UM8Urdn1CkiS7uV4Dn6EIMYi0rk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)