UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bz64qu4lOFE8MkzBHvpIElbtYZyxTNzRNylmFIngxb0='
WHERE
key_id = '7c92dad52b74394595899545eaaaeadc4b0e88fb4bc53778a1219f30b730bb16'
AND (
token = 'Bz64qu4lOFE8MkzBHvpIElbtYZyxTNzRNylmFIngxb0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)