UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YnzZIwbm5YDmbLaEfXtLY8+pkRyoMDTxGM7XNLHLoXw='
WHERE
key_id = 'e95342069fbb45d460b5e476fbd4dcee4e98009b58f89d91b6498bcea98f8c03'
AND (
token = 'YnzZIwbm5YDmbLaEfXtLY8+pkRyoMDTxGM7XNLHLoXw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)